Of note, the switch between CleanChoice and Pepco. It makes Feb 2021 unusually low, and June 2023 unusually high.
Mobile users!
Landscape mode is your friend
Total Amount spent: $20,230.16
Total Amount per Person: $6,743.39
Date Range: November 2020 - February 2025
As part of the process of switching between electric companies, June of 2023 charged an unusally high amount after shortchanging the prior month. In a few short plots, I will move some of that money from June to May of 2023, at this point in the analysis, to more accurately reflect what billing should have been.
At the same point, I will consolidate "Pepco" and "CleanChoice" into one creatively-named value, "Electric". Accounting wizardry.
In the spirit of data assumptions, I manually updated December 2023 through April 2024, to account for the weird stretch where the utility company only billed $19/month and created a giant backlog of debt that had to be paid off.
Some days, you're just on hold with the Electric company.
This is the only time you'll see the Pepco / CleanChoice data. After this, they'll be consolidated into "Electric"
Here is where I consolidate CleanChoice and Pepco into "Electric". I also pull a sneaky trick and move $143.50 from June 2023 to May 2023. See intro.
| Amount | Amount_per_person | |
|---|---|---|
| count | 52.000000 | 52.000000 |
| mean | 389.041538 | 129.680513 |
| std | 79.642766 | 26.547589 |
| min | 194.000000 | 64.666667 |
| 25% | 339.865000 | 113.288333 |
| 50% | 390.305000 | 130.101667 |
| 75% | 425.167500 | 141.722500 |
| max | 579.930000 | 193.310000 |